SaRefundCalculationWorkflowAudit 
EntityType  Independent 
Logical Entity Name  SaRefundCalculationWorkflowAudit 
Default Table Name  SaRefundCalculationWorkflowAudit 
Logical Only  NO 
Definition 
 
Note 
 

SaRefundCalculationWorkflowAudit Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
SaRefundCalculationWorkflowAuditID(PK)    INTEGER  NO 
 
SaRefundCalcId(FK)    INTEGER  YES 
 
SaReturnOfT4Id(FK)    INTEGER  YES 
 
PreviousStatusId(FK)    INTEGER  YES 
 
CurrentStatusId(FK)    INTEGER  YES 
 
PreviousAssignedStaffId(FK)    INTEGER  YES 
 
CurrentAssignedStaffId(FK)    INTEGER  YES 
 
PreviousAssignedStaffGroupId(FK)    INTEGER  YES 
 
CurrentAssignedStaffGroupId(FK)    INTEGER  YES 
 
PreviousLockedById(FK)    INTEGER  YES 
 
CurrentLockById(FK)    INTEGER  YES 
 
PreviousLockedOn    DATETIME  YES 
 
CurrentLockedOn    DATETIME  YES 
 
Comments    VARCHAR(5000)  NO 
 
UserID(FK)    INTEGER  NO 
 
DateAdded    DATETIME  NO 
 
DateLstMod    DATETIME  NO 
 
ts    TIMESTAMP/DATE  NO 
 
PreviousActionId(FK)    INTEGER  NO 
 
CurrentActionId(FK)    INTEGER  NO 
 

SaRefundCalculationWorkflowAudit Keys 
Key Name  Key Type  Keys 
Nk_SaRefundCalculationWorkflowAudit_PreviousActionId  Inversion Entry  PreviousActionId 
Nk_SaRefundCalculationWorkflowAudit_CurrentLockById  Inversion Entry  CurrentLockById 
Nk_SaRefundCalculationWorkflowAudit_PreviousLockedById  Inversion Entry  PreviousLockedById 
Nk_SaRefundCalculationWorkflowAudit_CurrentAssignedStaffGroupId  Inversion Entry  CurrentAssignedStaffGroupId 
Nk_SaRefundCalculationWorkflowAudit_PreviousStatusId  Inversion Entry  PreviousStatusId 
Nk_SaRefundCalculationWorkflowAudit_SaReturnOfT4Id  Inversion Entry  SaReturnOfT4Id 
Nk_SaRefundCalculationWorkflowAudit_SaRefundCalcId  Inversion Entry  SaRefundCalcId 
Nk_SaRefundCalculationWorkflowAudit_UserID  Inversion Entry  UserID 
Nk_SaRefundCalculationWorkflowAudit_CurrentActionId  Inversion Entry  CurrentActionId 
Nk_SaRefundCalculationWorkflowAudit_PreviousAssignedStaffGroupId  Inversion Entry  PreviousAssignedStaffGroupId 
Nk_SaRefundCalculationWorkflowAudit_CurrentAssignedStaffId  Inversion Entry  CurrentAssignedStaffId 
Nk_SaRefundCalculationWorkflowAudit_PreviousAssignedStaffId  Inversion Entry  PreviousAssignedStaffId 
Nk_SaRefundCalculationWorkflowAudit_CurrentStatusId  Inversion Entry  CurrentStatusId 
PK_SaRefundCalculationWorkflowAudit_SaRefundCalculationWorkflowAuditID  PrimaryKey  SaRefundCalculationWorkflowAuditID 

SaRefundCalculationWorkflowAudit Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
RefundCalculationAction  Non-Identifying  One To Zero or More        CurrentActionId  NO 
StaffGroup  Non-Identifying  Zero or One to Zero or More        CurrentAssignedStaffGroupId  NO 
Staff  Non-Identifying  Zero or One to Zero or More        CurrentAssignedStaffId  NO 
Staff  Non-Identifying  Zero or One to Zero or More        CurrentLockById  NO 
RefundCalculationStatus  Non-Identifying  Zero or One to Zero or More        CurrentStatusId  NO 
RefundCalculationAction  Non-Identifying  One To Zero or More        PreviousActionId  NO 
StaffGroup  Non-Identifying  Zero or One to Zero or More        PreviousAssignedStaffGroupId  NO 
Staff  Non-Identifying  Zero or One to Zero or More        PreviousAssignedStaffId  NO 
Staff  Non-Identifying  Zero or One to Zero or More        PreviousLockedById  NO 
RefundCalculationStatus  Non-Identifying  Zero or One to Zero or More        PreviousStatusId  NO 
StudentRefundCalculation  Non-Identifying  Zero or One to Zero or More        SaRefundCalcId  NO 
StudentRt4Calculation  Non-Identifying  Zero or One to Zero or More        SaReturnOfT4Id  NO 
Staff  Non-Identifying  One To Zero or More        UserID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

SaRefundCalculationWorkflowAudit Check Constraints 
Check Constraint Name  CheckConstraint